https://store-images.s-microsoft.com/image/apps.38934.6dbda2e6-87d6-463f-9497-36ca34143351.a187463f-52ce-408a-abbd-5905c629fc79.742ca76f-f274-4445-b60f-5d0599a2c0ba

Auto Create Dimensions

by ERP Connect Consulting LLC

Free trial badge
(4 ratings)

Sync Master Data and Dimension Values


Currently supported localizations include the United States and Canada.

Includes Free 30-Day Trial.


Auto Create Dimensions (ACD) gives Business Central users the ability to sync various master data records to dimension values in the system. This helps reduce setup and maintenance time for each dimension value and also let’s you report on sub-ledger data like Customer, Vendor, and Item directly from the General Ledger.


Popular Use Cases

  • Create a Customer Dimension and Sync Customer Master records to the dimension. This allows you to report on customer data directly from the General Ledger.
  • Create a Vendor Dimension and Sync Vendor Master records to the dimension. This allows you to report on vendor data directly from the General Ledger.
  • Create an Item Dimension and Sync Item Master records to the dimension. This allows you to report on Item data directly from the General Ledger.
  • Link the Customer/Vendor/Item Dimension as a required default dimension (optional) from the master record it came from.

Link Customer Data to Dimensions:
  • Customer Number
  • Customer Posting Group
  • General Business Posting Group
  • Customer State
  • Customer Country/Region

Link Item Data to Dimensions:
  • Item Number
  • Item Category
  • General Product Posting Group
  • Item Vendor Number
  • Location Code

Link Vendor Data to Dimensions:
  • Vendor Number

Link Resource, Salesperson, and Employee Data to Dimensions:
  • Resource Number
  • Resource Group
  • Salesperson Code
  • Purchaser Code
  • Employee Number


At a glance

https://store-images.s-microsoft.com/image/apps.7823.6dbda2e6-87d6-463f-9497-36ca34143351.a845424d-693c-4705-8217-1e370ed6eba6.73724dc7-4d8a-403b-a7d3-754dbc453ba8
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.33212.6dbda2e6-87d6-463f-9497-36ca34143351.92ced04e-03fc-46a6-973e-7bc168d95471.09d13cd6-0090-41d6-bb14-466a7b3555f9
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.41730.6dbda2e6-87d6-463f-9497-36ca34143351.92ced04e-03fc-46a6-973e-7bc168d95471.780b26ef-34ff-4201-a148-49d7904d4350
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.34070.6dbda2e6-87d6-463f-9497-36ca34143351.08c8f8fe-2ae5-418b-82d1-fb1598a62610.d68cbdca-9f3b-487c-a55c-043a9995aec5
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.15408.6dbda2e6-87d6-463f-9497-36ca34143351.c3c59ef1-c542-46e5-8ae1-8039e51f7875.4eab0475-1861-4b39-8ce8-74df67605aff
https://store-images.s-microsoft.com/image/apps.24027.6dbda2e6-87d6-463f-9497-36ca34143351.c3c59ef1-c542-46e5-8ae1-8039e51f7875.533dc2c0-be53-4fec-9045-45b1a49e847e
https://store-images.s-microsoft.com/image/apps.50346.6dbda2e6-87d6-463f-9497-36ca34143351.c3c59ef1-c542-46e5-8ae1-8039e51f7875.bbf7badd-d5e5-4121-aa36-075dee660b3d